Data Quality Analysis

Dataset statistics

Number of variables	28
Number of observations	280404
Missing cells	2768016
Missing cells (%)	35.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	56.4 MiB
Average record size in memory	211.0 B

Variable types

Unsupported	1
DateTime	3
Categorical	15
Numeric	9

Warnings

`Measure Period` has constant value "2020Q1-2020Q4"	Constant
`Processing Date` has constant value "2021-06-01 00:00:00"	Constant
`Provider Name` has a high cardinality: 15044 distinct values	High cardinality
`Provider Address` has a high cardinality: 15271 distinct values	High cardinality
`Provider City` has a high cardinality: 5243 distinct values	High cardinality
`Provider State` has a high cardinality: 53 distinct values	High cardinality
`Location` has a high cardinality: 15289 distinct values	High cardinality
`Q1 Measure Score` is highly correlated with `Q2 Measure Score` and 3 other fields	High correlation
`Footnote for Q1 Measure Score` is highly correlated with `Footnote for Q2 Measure Score` and 3 other fields	High correlation
`Q2 Measure Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q2 Measure Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Q3 Measure Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q3 Measure Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Q4 Measure Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q4 Measure Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Four Quarter Average Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Four Quarter Average Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Q1 Measure Score` is highly correlated with `Q2 Measure Score` and 3 other fields	High correlation
`Footnote for Q1 Measure Score` is highly correlated with `Footnote for Q2 Measure Score` and 3 other fields	High correlation
`Q2 Measure Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q2 Measure Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Q3 Measure Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q3 Measure Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Q4 Measure Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q4 Measure Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Four Quarter Average Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Four Quarter Average Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Q1 Measure Score` is highly correlated with `Q2 Measure Score` and 3 other fields	High correlation
`Footnote for Q1 Measure Score` is highly correlated with `Footnote for Q2 Measure Score` and 3 other fields	High correlation
`Q2 Measure Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q2 Measure Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Q3 Measure Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q3 Measure Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Q4 Measure Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q4 Measure Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Four Quarter Average Score` is highly correlated with `Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Four Quarter Average Score` is highly correlated with `Footnote for Q1 Measure Score` and 3 other fields	High correlation
`Footnote for Q3 Measure Score` is highly correlated with `Footnote for Q4 Measure Score` and 3 other fields	High correlation
`Provider Zip Code` is highly correlated with `Provider State`	High correlation
`Payment Denial Length in Days` is highly correlated with `Payment Denial Start Date`	High correlation
`Measure Code` is highly correlated with `Four Quarter Average Score` and 6 other fields	High correlation
`Four Quarter Average Score` is highly correlated with `Measure Code` and 7 other fields	High correlation
`Footnote for Q4 Measure Score` is highly correlated with `Footnote for Q3 Measure Score` and 3 other fields	High correlation
`Resident type` is highly correlated with `Measure Code` and 6 other fields	High correlation
`Q1 Measure Score` is highly correlated with `Measure Code` and 7 other fields	High correlation
`Footnote for Q1 Measure Score` is highly correlated with `Footnote for Q3 Measure Score` and 4 other fields	High correlation
`Q2 Measure Score` is highly correlated with `Measure Code` and 7 other fields	High correlation
`Measure Description` is highly correlated with `Measure Code` and 7 other fields	High correlation
`Q3 Measure Score` is highly correlated with `Measure Code` and 7 other fields	High correlation
`Q4 Measure Score` is highly correlated with `Measure Code` and 7 other fields	High correlation
`Used in Quality Measure Five Star Rating` is highly correlated with `Four Quarter Average Score` and 5 other fields	High correlation
`Provider State` is highly correlated with `Provider Zip Code`	High correlation
`Footnote for Q2 Measure Score` is highly correlated with `Footnote for Q3 Measure Score` and 3 other fields	High correlation
`Payment Denial Start Date` is highly correlated with `Payment Denial Length in Days` and 1 other fields	High correlation
`Footnote for Four Quarter Average Score` is highly correlated with `Footnote for Q3 Measure Score` and 3 other fields	High correlation
`Footnote for Q3 Measure Score` is highly correlated with `Footnote for Q2 Measure Score` and 4 other fields	High correlation
`Penalty Type` is highly correlated with `Provider State` and 1 other fields	High correlation
`Used in Quality Measure Five Star Rating` is highly correlated with `Measure Period` and 1 other fields	High correlation
`Provider State` is highly correlated with `Penalty Type` and 1 other fields	High correlation
`Footnote for Q2 Measure Score` is highly correlated with `Footnote for Q3 Measure Score` and 4 other fields	High correlation
`Footnote for Q4 Measure Score` is highly correlated with `Footnote for Q3 Measure Score` and 4 other fields	High correlation
`Measure Period` is highly correlated with `Footnote for Q3 Measure Score` and 9 other fields	High correlation
`Resident type` is highly correlated with `Measure Period` and 1 other fields	High correlation
`Footnote for Four Quarter Average Score` is highly correlated with `Footnote for Q3 Measure Score` and 4 other fields	High correlation
`Footnote for Q1 Measure Score` is highly correlated with `Footnote for Q3 Measure Score` and 4 other fields	High correlation
`Measure Description` is highly correlated with `Used in Quality Measure Five Star Rating` and 2 other fields	High correlation
`Penalty Date` has 269056 (96.0%) missing values	Missing
`Penalty Type` has 269056 (96.0%) missing values	Missing
`Fine Amount` has 271036 (96.7%) missing values	Missing
`Payment Denial Start Date` has 278424 (99.3%) missing values	Missing
`Payment Denial Length in Days` has 278424 (99.3%) missing values	Missing
`Q1 Measure Score` has 38495 (13.7%) missing values	Missing
`Footnote for Q1 Measure Score` has 241909 (86.3%) missing values	Missing
`Q2 Measure Score` has 42302 (15.1%) missing values	Missing
`Footnote for Q2 Measure Score` has 238102 (84.9%) missing values	Missing
`Q3 Measure Score` has 46964 (16.7%) missing values	Missing
`Footnote for Q3 Measure Score` has 233440 (83.3%) missing values	Missing
`Q4 Measure Score` has 49932 (17.8%) missing values	Missing
`Footnote for Q4 Measure Score` has 230472 (82.2%) missing values	Missing
`Four Quarter Average Score` has 12836 (4.6%) missing values	Missing
`Footnote for Four Quarter Average Score` has 267568 (95.4%) missing values	Missing
`Provider Address` is uniformly distributed	Uniform
`Measure Description` is uniformly distributed	Uniform
`Used in Quality Measure Five Star Rating` is uniformly distributed	Uniform
`Location` is uniformly distributed	Uniform
`Federal Provider Number` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Q1 Measure Score` has 42205 (15.1%) zeros	Zeros
`Q2 Measure Score` has 41383 (14.8%) zeros	Zeros
`Q3 Measure Score` has 41932 (15.0%) zeros	Zeros
`Q4 Measure Score` has 42025 (15.0%) zeros	Zeros
`Four Quarter Average Score` has 28025 (10.0%) zeros	Zeros

Reproduction

Analysis started	2021-09-23 03:48:39.497993
Analysis finished	2021-09-23 03:49:35.753147
Duration	56.26 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

Federal Provider Number
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Penalty Date
Date

MISSING

Distinct	344
Distinct (%)	3.0%
Missing	269056
Missing (%)	96.0%
Memory size	4.3 MiB

Minimum	2018-01-04 00:00:00
Maximum	2021-03-18 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Penalty Type
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	269056
Missing (%)	96.0%
Memory size	2.4 MiB

Fine	9368
Payment Denial	1980

Length

Max length	14
Median length	4
Mean length	5.744800846
Min length	4

Characters and Unicode

Total characters	65192
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fine
2nd row	Fine
3rd row	Fine
4th row	Fine
5th row	Fine

Common Values

Value	Count	Frequency (%)
Fine	9368	3.3%
Payment Denial	1980	0.7%
(Missing)	269056	96.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
fine	9368	70.3%
denial	1980	14.9%
payment	1980	14.9%

Most occurring characters

Value	Count	Frequency (%)
n	13328	20.4%
e	13328	20.4%
i	11348	17.4%
F	9368	14.4%
a	3960	6.1%
P	1980	3.0%
y	1980	3.0%
m	1980	3.0%
t	1980	3.0%
	1980	3.0%
Other values (2)	3960	6.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	49884	76.5%
Uppercase Letter	13328	20.4%
Space Separator	1980	3.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	13328	26.7%
e	13328	26.7%
i	11348	22.7%
a	3960	7.9%
y	1980	4.0%
m	1980	4.0%
t	1980	4.0%
l	1980	4.0%

Uppercase Letter

Value	Count	Frequency (%)
F	9368	70.3%
P	1980	14.9%
D	1980	14.9%

Space Separator

Value	Count	Frequency (%)
	1980	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	63212	97.0%
Common	1980	3.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	13328	21.1%
e	13328	21.1%
i	11348	18.0%
F	9368	14.8%
a	3960	6.3%
P	1980	3.1%
y	1980	3.1%
m	1980	3.1%
t	1980	3.1%
D	1980	3.1%

Common

Value	Count	Frequency (%)
	1980	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	65192	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	13328	20.4%
e	13328	20.4%
i	11348	17.4%
F	9368	14.4%
a	3960	6.1%
P	1980	3.0%
y	1980	3.0%
m	1980	3.0%
t	1980	3.0%
	1980	3.0%
Other values (2)	3960	6.1%

Fine Amount
Real number (ℝ_≥0)

MISSING

Distinct	255
Distinct (%)	2.7%
Missing	271036
Missing (%)	96.7%
Infinite	0
Infinite (%)	0.0%
Mean	20786.27989

Minimum	650
Maximum	236145
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	650
5-th percentile	650
Q1	1625
median	9750
Q3	20192
95-th percentile	99956
Maximum	236145
Range	235495
Interquartile range (IQR)	18567

Descriptive statistics

Standard deviation	35268.4078
Coefficient of variation (CV)	1.696715717
Kurtosis	13.78118416
Mean	20786.27989
Median Absolute Deviation (MAD)	8125
Skewness	3.42938224
Sum	194725870
Variance	1243860588
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
650	1170	0.4%
975	666	0.2%
9750	486	0.2%
1300	306	0.1%
5000	270	0.1%
1625	252	0.1%
3250	198	0.1%
13905	180	0.1%
7296	162	0.1%
7157	152	0.1%
Other values (245)	5526	2.0%
(Missing)	271036	96.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
650	1170	0.4%
975	666	0.2%
1000	36	< 0.1%
1300	306	0.1%
1625	252	0.1%
1950	108	< 0.1%
2275	18	< 0.1%
2600	18	< 0.1%
3250	198	0.1%
3318	18	< 0.1%

Value	Count	Frequency (%)
236145	18	< 0.1%
229843	18	< 0.1%
228015	18	< 0.1%
221521	18	< 0.1%
219805	18	< 0.1%
207058	18	< 0.1%
177190	18	< 0.1%
164740	18	< 0.1%
153030	18	< 0.1%
147847	18	< 0.1%

Payment Denial Start Date
Date

HIGH CORRELATION
MISSING

Distinct	99
Distinct (%)	5.0%
Missing	278424
Missing (%)	99.3%
Memory size	4.3 MiB

Minimum	2018-07-11 00:00:00
Maximum	2021-04-15 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Payment Denial Length in Days
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	54
Distinct (%)	2.7%
Missing	278424
Missing (%)	99.3%
Infinite	0
Infinite (%)	0.0%
Mean	28.43636364

Minimum	1
Maximum	391
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	7
median	17
Q3	33
95-th percentile	90
Maximum	391
Range	390
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	42.68598684
Coefficient of variation (CV)	1.501105675
Kurtosis	45.07127208
Mean	28.43636364
Median Absolute Deviation (MAD)	11.5
Skewness	5.834802785
Sum	56304
Variance	1822.093472
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	144	0.1%
11	108	< 0.1%
5	90	< 0.1%
7	90	< 0.1%
6	90	< 0.1%
3	72	< 0.1%
14	72	< 0.1%
27	72	< 0.1%
33	72	< 0.1%
13	54	< 0.1%
Other values (44)	1116	0.4%
(Missing)	278424	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	144	0.1%
2	18	< 0.1%
3	72	< 0.1%
4	36	< 0.1%
5	90	< 0.1%
6	90	< 0.1%
7	90	< 0.1%
8	36	< 0.1%
9	54	< 0.1%
10	18	< 0.1%

Value	Count	Frequency (%)
391	18	< 0.1%
119	18	< 0.1%
118	18	< 0.1%
97	18	< 0.1%
93	18	< 0.1%
90	18	< 0.1%
73	18	< 0.1%
72	18	< 0.1%
67	18	< 0.1%
65	18	< 0.1%

Provider Name
Categorical

HIGH CARDINALITY

Distinct	15044
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

MILLER'S MERRY MANOR	540
BENDER TERRACE OF LUBBOCK	198
ARDEN WOOD	198
MANORCARE HEALTH SERVICES	162
RANGER CARE CENTER	126
Other values (15039)	279180

Length

Max length	50
Median length	28
Mean length	29.70804981
Min length	6

Characters and Unicode

Total characters	8330256
Distinct characters	50
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BURNS NURSING HOME, INC.
2nd row	BURNS NURSING HOME, INC.
3rd row	BURNS NURSING HOME, INC.
4th row	BURNS NURSING HOME, INC.
5th row	BURNS NURSING HOME, INC.

Common Values

Value	Count	Frequency (%)
MILLER'S MERRY MANOR	540	0.2%
BENDER TERRACE OF LUBBOCK	198	0.1%
ARDEN WOOD	198	0.1%
MANORCARE HEALTH SERVICES	162	0.1%
RANGER CARE CENTER	126	< 0.1%
BRIGHTPOINTE AT LYTLE LAKE	126	< 0.1%
PARKVIEW CARE CENTER	108	< 0.1%
WINDSOR PLACE	108	< 0.1%
LITTLE SISTERS OF THE POOR	108	< 0.1%
COMMUNITY CARE CENTER	90	< 0.1%
Other values (15034)	278640	99.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
center	106794	8.8%
care	56970	4.7%
rehabilitation	54522	4.5%
nursing	51174	4.2%
and	50202	4.1%
health	45162	3.7%
	37908	3.1%
of	30798	2.5%
healthcare	26010	2.1%
rehab	25632	2.1%
Other values (7521)	735282	60.2%

Most occurring characters

Value	Count	Frequency (%)
E	953424	11.4%
	941958	11.3%
A	750438	9.0%
R	662022	7.9%
N	635652	7.6%
T	588312	7.1%
I	529092	6.4%
L	435312	5.2%
O	413046	5.0%
C	384426	4.6%
Other values (40)	2036574	24.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7312428	87.8%
Space Separator	941958	11.3%
Other Punctuation	55566	0.7%
Dash Punctuation	15606	0.2%
Open Punctuation	2052	< 0.1%
Close Punctuation	1980	< 0.1%
Decimal Number	630	< 0.1%
Final Punctuation	36	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	953424	13.0%
A	750438	10.3%
R	662022	9.1%
N	635652	8.7%
T	588312	8.0%
I	529092	7.2%
L	435312	6.0%
O	413046	5.6%
C	384426	5.3%
H	384012	5.3%
Other values (16)	1576692	21.6%

Decimal Number

Value	Count	Frequency (%)
1	126	20.0%
2	108	17.1%
0	90	14.3%
3	90	14.3%
4	72	11.4%
9	54	8.6%
7	36	5.7%
6	18	2.9%
5	18	2.9%
8	18	2.9%

Other Punctuation

Value	Count	Frequency (%)
&	29862	53.7%
,	17766	32.0%
'	3708	6.7%
.	2142	3.9%
/	1962	3.5%
"	36	0.1%
#	36	0.1%
:	36	0.1%
@	18	< 0.1%

Space Separator

Value	Count	Frequency (%)
	941958	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	15606	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2052	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1980	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	36	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7312428	87.8%
Common	1017828	12.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	953424	13.0%
A	750438	10.3%
R	662022	9.1%
N	635652	8.7%
T	588312	8.0%
I	529092	7.2%
L	435312	6.0%
O	413046	5.6%
C	384426	5.3%
H	384012	5.3%
Other values (16)	1576692	21.6%

Common

Value	Count	Frequency (%)
	941958	92.5%
&	29862	2.9%
,	17766	1.7%
-	15606	1.5%
'	3708	0.4%
.	2142	0.2%
(	2052	0.2%
)	1980	0.2%
/	1962	0.2%
1	126	< 0.1%
Other values (14)	666	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8330220	> 99.9%
Punctuation	36	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	953424	11.4%
	941958	11.3%
A	750438	9.0%
R	662022	7.9%
N	635652	7.6%
T	588312	7.1%
I	529092	6.4%
L	435312	5.2%
O	413046	5.0%
C	384426	4.6%
Other values (39)	2036538	24.4%

Punctuation

Value	Count	Frequency (%)
’	36	100.0%

Provider Address
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	15271
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

4510 27TH ST	198
8810 LONG POINT DR	198
1201 CLARKS DR	126
460 W MAIN ST	126
507 E W M WATSON BLVD	108
Other values (15266)	279648

Length

Max length	50
Median length	18
Mean length	18.73507511
Min length	7

Characters and Unicode

Total characters	5253390
Distinct characters	54
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	701 MONROE STREET NW
2nd row	701 MONROE STREET NW
3rd row	701 MONROE STREET NW
4th row	701 MONROE STREET NW
5th row	701 MONROE STREET NW

Common Values

Value	Count	Frequency (%)
4510 27TH ST	198	0.1%
8810 LONG POINT DR	198	0.1%
1201 CLARKS DR	126	< 0.1%
460 W MAIN ST	126	< 0.1%
507 E W M WATSON BLVD	108	< 0.1%
3000 MOCKINGBIRD LN	90	< 0.1%
11830 NORTHPOINTE BOULEVARD	90	< 0.1%
1260 ABRAMS RD	90	< 0.1%
6211 S NEW BRAUNFELS AVE	90	< 0.1%
3640 HAMPTON DR	90	< 0.1%
Other values (15261)	279198	99.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
street	53280	5.3%
road	39564	4.0%
avenue	31896	3.2%
drive	25326	2.5%
st	23436	2.3%
ave	16686	1.7%
rd	15606	1.6%
north	15048	1.5%
west	14562	1.5%
south	14130	1.4%
Other values (10672)	748962	75.0%

Most occurring characters

Value	Count	Frequency (%)
	721566	13.7%
E	472860	9.0%
R	330714	6.3%
T	320490	6.1%
A	304254	5.8%
S	239454	4.6%
O	226332	4.3%
N	224172	4.3%
0	218574	4.2%
1	208098	4.0%
Other values (44)	1986876	37.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3453192	65.7%
Decimal Number	1061388	20.2%
Space Separator	721566	13.7%
Other Punctuation	14904	0.3%
Dash Punctuation	2106	< 0.1%
Lowercase Letter	162	< 0.1%
Open Punctuation	36	< 0.1%
Close Punctuation	36	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	472860	13.7%
R	330714	9.6%
T	320490	9.3%
A	304254	8.8%
S	239454	6.9%
O	226332	6.6%
N	224172	6.5%
D	173700	5.0%
I	160758	4.7%
L	156114	4.5%
Other values (16)	844344	24.5%

Decimal Number

Value	Count	Frequency (%)
0	218574	20.6%
1	208098	19.6%
2	124758	11.8%
5	111330	10.5%
3	92970	8.8%
4	78102	7.4%
6	63000	5.9%
7	58968	5.6%
9	52866	5.0%
8	52722	5.0%

Lowercase Letter

Value	Count	Frequency (%)
a	36	22.2%
i	18	11.1%
r	18	11.1%
b	18	11.1%
n	18	11.1%
k	18	11.1%
s	18	11.1%
d	18	11.1%

Other Punctuation

Value	Count	Frequency (%)
.	9576	64.3%
,	3960	26.6%
'	522	3.5%
#	360	2.4%
/	270	1.8%
&	216	1.4%

Space Separator

Value	Count	Frequency (%)
	721566	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2106	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	36	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	36	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3453354	65.7%
Common	1800036	34.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	472860	13.7%
R	330714	9.6%
T	320490	9.3%
A	304254	8.8%
S	239454	6.9%
O	226332	6.6%
N	224172	6.5%
D	173700	5.0%
I	160758	4.7%
L	156114	4.5%
Other values (24)	844506	24.5%

Common

Value	Count	Frequency (%)
	721566	40.1%
0	218574	12.1%
1	208098	11.6%
2	124758	6.9%
5	111330	6.2%
3	92970	5.2%
4	78102	4.3%
6	63000	3.5%
7	58968	3.3%
9	52866	2.9%
Other values (10)	69804	3.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5253390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	721566	13.7%
E	472860	9.0%
R	330714	6.3%
T	320490	6.1%
A	304254	5.8%
S	239454	4.6%
O	226332	4.3%
N	224172	4.3%
0	218574	4.2%
1	208098	4.0%
Other values (44)	1986876	37.8%

Provider City
Categorical

HIGH CARDINALITY

Distinct	5243
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

HOUSTON	1962
LOS ANGELES	1422
CHICAGO	1422
SAN ANTONIO	1332
CINCINNATI	1296
Other values (5238)	272970

Length

Max length	20
Median length	8
Mean length	8.770766466
Min length	3

Characters and Unicode

Total characters	2459358
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RUSSELLVILLE
2nd row	RUSSELLVILLE
3rd row	RUSSELLVILLE
4th row	RUSSELLVILLE
5th row	RUSSELLVILLE

Common Values

Value	Count	Frequency (%)
HOUSTON	1962	0.7%
LOS ANGELES	1422	0.5%
CHICAGO	1422	0.5%
SAN ANTONIO	1332	0.5%
CINCINNATI	1296	0.5%
COLUMBUS	1026	0.4%
DALLAS	936	0.3%
LOUISVILLE	936	0.3%
INDIANAPOLIS	900	0.3%
SPRINGFIELD	900	0.3%
Other values (5233)	268272	95.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
city	7650	2.2%
san	3726	1.1%
new	2970	0.8%
saint	2772	0.8%
fort	2538	0.7%
west	2466	0.7%
beach	2430	0.7%
park	2394	0.7%
lake	2286	0.7%
houston	1962	0.6%
Other values (4628)	318708	91.1%

Most occurring characters

Value	Count	Frequency (%)
E	236772	9.6%
A	228366	9.3%
N	201744	8.2%
O	195912	8.0%
L	192330	7.8%
R	171072	7.0%
I	160218	6.5%
T	140760	5.7%
S	139986	5.7%
C	81540	3.3%
Other values (19)	710658	28.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2389590	97.2%
Space Separator	69498	2.8%
Dash Punctuation	162	< 0.1%
Other Punctuation	108	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	236772	9.9%
A	228366	9.6%
N	201744	8.4%
O	195912	8.2%
L	192330	8.0%
R	171072	7.2%
I	160218	6.7%
T	140760	5.9%
S	139986	5.9%
C	81540	3.4%
Other values (16)	640890	26.8%

Space Separator

Value	Count	Frequency (%)
	69498	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	108	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	162	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2389590	97.2%
Common	69768	2.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	236772	9.9%
A	228366	9.6%
N	201744	8.4%
O	195912	8.2%
L	192330	8.0%
R	171072	7.2%
I	160218	6.7%
T	140760	5.9%
S	139986	5.9%
C	81540	3.4%
Other values (16)	640890	26.8%

Common

Value	Count	Frequency (%)
	69498	99.6%
-	162	0.2%
'	108	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2459358	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	236772	9.6%
A	228366	9.3%
N	201744	8.2%
O	195912	8.0%
L	192330	7.8%
R	171072	7.0%
I	160218	6.5%
T	140760	5.7%
S	139986	5.7%
C	81540	3.3%
Other values (19)	710658	28.9%

Provider State
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

TX	26766
CA	21294
OH	17172
IL	12744
FL	12672
Other values (48)	189756

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	560808
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AL
2nd row	AL
3rd row	AL
4th row	AL
5th row	AL

Common Values

Value	Count	Frequency (%)
TX	26766	9.5%
CA	21294	7.6%
OH	17172	6.1%
IL	12744	4.5%
FL	12672	4.5%
PA	12366	4.4%
NY	11088	4.0%
IN	9594	3.4%
MO	9288	3.3%
MI	7830	2.8%
Other values (43)	139590	49.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tx	26766	9.5%
ca	21294	7.6%
oh	17172	6.1%
il	12744	4.5%
fl	12672	4.5%
pa	12366	4.4%
ny	11088	4.0%
in	9594	3.4%
mo	9288	3.3%
mi	7830	2.8%
Other values (43)	139590	49.8%

Most occurring characters

Value	Count	Frequency (%)
A	79416	14.2%
N	55710	9.9%
I	47826	8.5%
M	42264	7.5%
C	40518	7.2%
T	39798	7.1%
O	38214	6.8%
L	34488	6.1%
X	26766	4.8%
H	19260	3.4%
Other values (14)	136548	24.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	560808	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	79416	14.2%
N	55710	9.9%
I	47826	8.5%
M	42264	7.5%
C	40518	7.2%
T	39798	7.1%
O	38214	6.8%
L	34488	6.1%
X	26766	4.8%
H	19260	3.4%
Other values (14)	136548	24.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	560808	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	79416	14.2%
N	55710	9.9%
I	47826	8.5%
M	42264	7.5%
C	40518	7.2%
T	39798	7.1%
O	38214	6.8%
L	34488	6.1%
X	26766	4.8%
H	19260	3.4%
Other values (14)	136548	24.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	560808	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	79416	14.2%
N	55710	9.9%
I	47826	8.5%
M	42264	7.5%
C	40518	7.2%
T	39798	7.1%
O	38214	6.8%
L	34488	6.1%
X	26766	4.8%
H	19260	3.4%
Other values (14)	136548	24.3%

Provider Zip Code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9181
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50784.27789

Minimum	660
Maximum	99929
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	660
5-th percentile	6471
Q1	30120
median	49507
Q3	74133
95-th percentile	94109
Maximum	99929
Range	99269
Interquartile range (IQR)	44013

Descriptive statistics

Standard deviation	26843.76914
Coefficient of variation (CV)	0.5285842441
Kurtosis	-1.006868665
Mean	50784.27789
Median Absolute Deviation (MAD)	21598.5
Skewness	-0.04423245
Sum	1.424011466 × 10¹⁰
Variance	720587941.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
79410	270	0.1%
77055	234	0.1%
94541	216	0.1%
11691	198	0.1%
63017	180	0.1%
33161	162	0.1%
85712	162	0.1%
77493	162	0.1%
91103	162	0.1%
21228	162	0.1%
Other values (9171)	278496	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
660	18	< 0.1%
693	18	< 0.1%
717	18	< 0.1%
792	18	< 0.1%
926	18	< 0.1%
928	18	< 0.1%
1001	90	< 0.1%
1002	18	< 0.1%
1013	36	< 0.1%
1020	18	< 0.1%

Value	Count	Frequency (%)
99929	18	< 0.1%
99901	18	< 0.1%
99835	18	< 0.1%
99833	18	< 0.1%
99801	18	< 0.1%
99762	18	< 0.1%
99752	18	< 0.1%
99701	18	< 0.1%
99686	18	< 0.1%
99669	18	< 0.1%

Measure Code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	427.8333333

Minimum	401
Maximum	472
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	401
5-th percentile	401
Q1	407
median	417
Q3	452
95-th percentile	472
Maximum	472
Range	71
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	23.94964256
Coefficient of variation (CV)	0.05597890743
Kurtosis	-1.189569187
Mean	427.8333333
Median Absolute Deviation (MAD)	13
Skewness	0.5664715388
Sum	119966178
Variance	573.5853789
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
401	15578	5.6%
404	15578	5.6%
471	15578	5.6%
454	15578	5.6%
453	15578	5.6%
452	15578	5.6%
451	15578	5.6%
434	15578	5.6%
430	15578	5.6%
419	15578	5.6%
Other values (8)	124624	44.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
401	15578	5.6%
404	15578	5.6%
405	15578	5.6%
406	15578	5.6%
407	15578	5.6%
408	15578	5.6%
409	15578	5.6%
410	15578	5.6%
415	15578	5.6%
419	15578	5.6%

Value	Count	Frequency (%)
472	15578	5.6%
471	15578	5.6%
454	15578	5.6%
453	15578	5.6%
452	15578	5.6%
451	15578	5.6%
434	15578	5.6%
430	15578	5.6%
419	15578	5.6%
415	15578	5.6%

Measure Description
Categorical

HIGH CORRELATION
HIGH CORRELATION
UNIFORM

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Percentage of long-stay residents who lose too much weight	15578
Percentage of long-stay residents whose need for help with daily activities has increased	15578
Percentage of long-stay residents who received an antianxiety or hypnotic medication	15578
Percentage of long-stay residents whose ability to move independently worsened	15578
Percentage of long-stay residents who have depressive symptoms	15578
Other values (13)	202514

Length

Max length	107
Median length	81.5
Mean length	79.16666667
Min length	58

Characters and Unicode

Total characters	22198650
Distinct characters	28
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Percentage of long-stay residents whose need for help with daily activities has increased
2nd row	Percentage of long-stay residents who lose too much weight
3rd row	Percentage of low risk long-stay residents who lose control of their bowels or bladder
4th row	Percentage of long-stay residents with a catheter inserted and left in their bladder
5th row	Percentage of long-stay residents with a urinary tract infection

Common Values

Value	Count	Frequency (%)
Percentage of long-stay residents who lose too much weight	15578	5.6%
Percentage of long-stay residents whose need for help with daily activities has increased	15578	5.6%
Percentage of long-stay residents who received an antianxiety or hypnotic medication	15578	5.6%
Percentage of long-stay residents whose ability to move independently worsened	15578	5.6%
Percentage of long-stay residents who have depressive symptoms	15578	5.6%
Percentage of long-stay residents assessed and appropriately given the seasonal influenza vaccine	15578	5.6%
Percentage of short-stay residents who newly received an antipsychotic medication	15578	5.6%
Percentage of long-stay residents experiencing one or more falls with major injury	15578	5.6%
Percentage of short-stay residents who were assessed and appropriately given the seasonal influenza vaccine	15578	5.6%
Percentage of high risk long-stay residents with pressure ulcers	15578	5.6%
Other values (8)	124624	44.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
of	295982	9.9%
percentage	280404	9.4%
residents	280404	9.4%
long-stay	218092	7.3%
who	140202	4.7%
and	77890	2.6%
with	77890	2.6%
appropriately	62312	2.1%
given	62312	2.1%
the	62312	2.1%
Other values (63)	1433176	47.9%

Most occurring characters

Value	Count	Frequency (%)
e	2850774	12.8%
	2710572	12.2%
n	1620112	7.3%
s	1604534	7.2%
t	1588956	7.2%
a	1448754	6.5%
o	1339708	6.0%
r	1277396	5.8%
i	1261818	5.7%
c	841212	3.8%
Other values (18)	5654814	25.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18927270	85.3%
Space Separator	2710572	12.2%
Uppercase Letter	280404	1.3%
Dash Punctuation	280404	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2850774	15.1%
n	1620112	8.6%
s	1604534	8.5%
t	1588956	8.4%
a	1448754	7.7%
o	1339708	7.1%
r	1277396	6.7%
i	1261818	6.7%
c	841212	4.4%
d	732166	3.9%
Other values (15)	4361840	23.0%

Uppercase Letter

Value	Count	Frequency (%)
P	280404	100.0%

Space Separator

Value	Count	Frequency (%)
	2710572	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	280404	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	19207674	86.5%
Common	2990976	13.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2850774	14.8%
n	1620112	8.4%
s	1604534	8.4%
t	1588956	8.3%
a	1448754	7.5%
o	1339708	7.0%
r	1277396	6.7%
i	1261818	6.6%
c	841212	4.4%
d	732166	3.8%
Other values (16)	4642244	24.2%

Common

Value	Count	Frequency (%)
	2710572	90.6%
-	280404	9.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	22198650	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2850774	12.8%
	2710572	12.2%
n	1620112	7.3%
s	1604534	7.2%
t	1588956	7.2%
a	1448754	6.5%
o	1339708	6.0%
r	1277396	5.8%
i	1261818	5.7%
c	841212	3.8%
Other values (18)	5654814	25.5%

Resident type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

Long Stay	218092
Short Stay	62312

Length

Max length	10
Median length	9
Mean length	9.222222222
Min length	9

Characters and Unicode

Total characters	2585948
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Long Stay
2nd row	Long Stay
3rd row	Long Stay
4th row	Long Stay
5th row	Long Stay

Common Values

Value	Count	Frequency (%)
Long Stay	218092	77.8%
Short Stay	62312	22.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
stay	280404	50.0%
long	218092	38.9%
short	62312	11.1%

Most occurring characters

Value	Count	Frequency (%)
S	342716	13.3%
t	342716	13.3%
o	280404	10.8%
	280404	10.8%
a	280404	10.8%
y	280404	10.8%
L	218092	8.4%
n	218092	8.4%
g	218092	8.4%
h	62312	2.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1744736	67.5%
Uppercase Letter	560808	21.7%
Space Separator	280404	10.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	342716	19.6%
o	280404	16.1%
a	280404	16.1%
y	280404	16.1%
n	218092	12.5%
g	218092	12.5%
h	62312	3.6%
r	62312	3.6%

Uppercase Letter

Value	Count	Frequency (%)
S	342716	61.1%
L	218092	38.9%

Space Separator

Value	Count	Frequency (%)
	280404	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2305544	89.2%
Common	280404	10.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	342716	14.9%
t	342716	14.9%
o	280404	12.2%
a	280404	12.2%
y	280404	12.2%
L	218092	9.5%
n	218092	9.5%
g	218092	9.5%
h	62312	2.7%
r	62312	2.7%

Common

Value	Count	Frequency (%)
	280404	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2585948	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	342716	13.3%
t	342716	13.3%
o	280404	10.8%
	280404	10.8%
a	280404	10.8%
y	280404	10.8%
L	218092	8.4%
n	218092	8.4%
g	218092	8.4%
h	62312	2.4%

Q1 Measure Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	42920
Distinct (%)	17.7%
Missing	38495
Missing (%)	13.7%
Infinite	0
Infinite (%)	0.0%
Mean	30.66815818

Minimum	0
Maximum	100
Zeros	42205
Zeros (%)	15.1%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.12766
median	10.71429
Q3	63.07692
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	60.94926

Descriptive statistics

Standard deviation	37.11705779
Coefficient of variation (CV)	1.210279978
Kurtosis	-0.8112827491
Mean	30.66815818
Median Absolute Deviation (MAD)	10.71429
Skewness	0.9432812526
Sum	7418903.476
Variance	1377.675979
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	42205	15.1%
100	15953	5.7%
10	863	0.3%
14.28571	818	0.3%
8.33333	782	0.3%
7.69231	770	0.3%
9.09091	750	0.3%
12.5	744	0.3%
4.7619	725	0.3%
16.66667	725	0.3%
Other values (42910)	177574	63.3%
(Missing)	38495	13.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	42205	15.1%
0.13441	1	< 0.1%
0.1626	1	< 0.1%
0.167023	1	< 0.1%
0.170557	1	< 0.1%
0.20284	1	< 0.1%
0.213921	1	< 0.1%
0.214709	1	< 0.1%
0.21739	1	< 0.1%
0.21882	1	< 0.1%

Value	Count	Frequency (%)
100	15953	5.7%
99.86413	1	< 0.1%
99.85486	1	< 0.1%
99.84326	2	< 0.1%
99.83687	1	< 0.1%
99.814471	1	< 0.1%
99.81168	2	< 0.1%
99.811321	1	< 0.1%
99.80989	1	< 0.1%
99.809524	1	< 0.1%

Footnote for Q1 Measure Score
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	241909
Missing (%)	86.3%
Memory size	4.3 MiB

9.0	36965
10.0	1530

Length

Max length	4
Median length	3
Mean length	3.039745421
Min length	3

Characters and Unicode

Total characters	117015
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9.0
2nd row	9.0
3rd row	9.0
4th row	9.0
5th row	9.0

Common Values

Value	Count	Frequency (%)
9.0	36965	13.2%
10.0	1530	0.5%
(Missing)	241909	86.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
9.0	36965	96.0%
10.0	1530	4.0%

Most occurring characters

Value	Count	Frequency (%)
0	40025	34.2%
.	38495	32.9%
9	36965	31.6%
1	1530	1.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	78520	67.1%
Other Punctuation	38495	32.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	40025	51.0%
9	36965	47.1%
1	1530	1.9%

Other Punctuation

Value	Count	Frequency (%)
.	38495	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	117015	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	40025	34.2%
.	38495	32.9%
9	36965	31.6%
1	1530	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	117015	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	40025	34.2%
.	38495	32.9%
9	36965	31.6%
1	1530	1.3%

Q2 Measure Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	41092
Distinct (%)	17.3%
Missing	42302
Missing (%)	15.1%
Infinite	0
Infinite (%)	0.0%
Mean	31.20409104

Minimum	0
Maximum	100
Zeros	41383
Zeros (%)	14.8%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.27273
median	11.9403
Q3	62.5
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	60.22727

Descriptive statistics

Standard deviation	36.95947342
Coefficient of variation (CV)	1.184443199
Kurtosis	-0.819722511
Mean	31.20409104
Median Absolute Deviation (MAD)	11.9403
Skewness	0.926289693
Sum	7429756.484
Variance	1366.002676
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	41383	14.8%
100	16269	5.8%
10	965	0.3%
14.28571	869	0.3%
12.5	807	0.3%
8.33333	785	0.3%
16.66667	765	0.3%
11.11111	758	0.3%
20	750	0.3%
4.34783	747	0.3%
Other values (41082)	174004	62.1%
(Missing)	42302	15.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	41383	14.8%
0.13387	1	< 0.1%
0.167583	1	< 0.1%
0.16978	1	< 0.1%
0.17212	1	< 0.1%
0.180396	1	< 0.1%
0.20704	1	< 0.1%
0.211952	1	< 0.1%
0.21368	1	< 0.1%
0.22936	1	< 0.1%

Value	Count	Frequency (%)
100	16269	5.8%
99.84448	1	< 0.1%
99.82788	1	< 0.1%
99.82111	1	< 0.1%
99.814471	1	< 0.1%
99.811321	1	< 0.1%
99.809524	1	< 0.1%
99.80695	1	< 0.1%
99.80159	1	< 0.1%
99.79716	1	< 0.1%

Footnote for Q2 Measure Score
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	238102
Missing (%)	84.9%
Memory size	4.3 MiB

9.0	41154
10.0	1148

Length

Max length	4
Median length	3
Mean length	3.027138197
Min length	3

Characters and Unicode

Total characters	128054
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9.0
2nd row	9.0
3rd row	9.0
4th row	9.0
5th row	9.0

Common Values

Value	Count	Frequency (%)
9.0	41154	14.7%
10.0	1148	0.4%
(Missing)	238102	84.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
9.0	41154	97.3%
10.0	1148	2.7%

Most occurring characters

Value	Count	Frequency (%)
0	43450	33.9%
.	42302	33.0%
9	41154	32.1%
1	1148	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	85752	67.0%
Other Punctuation	42302	33.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	43450	50.7%
9	41154	48.0%
1	1148	1.3%

Other Punctuation

Value	Count	Frequency (%)
.	42302	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	128054	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	43450	33.9%
.	42302	33.0%
9	41154	32.1%
1	1148	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	128054	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	43450	33.9%
.	42302	33.0%
9	41154	32.1%
1	1148	0.9%

Q3 Measure Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	38292
Distinct (%)	16.4%
Missing	46964
Missing (%)	16.7%
Infinite	0
Infinite (%)	0.0%
Mean	30.97604272

Minimum	0
Maximum	100
Zeros	41932
Zeros (%)	15.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.29007875
median	11.90476
Q3	61.29032
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	59.00024125

Descriptive statistics

Standard deviation	36.85429636
Coefficient of variation (CV)	1.189767741
Kurtosis	-0.7880609993
Mean	30.97604272
Median Absolute Deviation (MAD)	11.90476
Skewness	0.9426342918
Sum	7231047.413
Variance	1358.23916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	41932	15.0%
100	15906	5.7%
10	918	0.3%
14.28571	911	0.3%
12.5	883	0.3%
9.09091	849	0.3%
8.33333	826	0.3%
16.66667	807	0.3%
11.11111	800	0.3%
20	769	0.3%
Other values (38282)	168839	60.2%
(Missing)	46964	16.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	41932	15.0%
0.13928	1	< 0.1%
0.1996	1	< 0.1%
0.23474	1	< 0.1%
0.235869	1	< 0.1%
0.241707	1	< 0.1%
0.243656	1	< 0.1%
0.24691	1	< 0.1%
0.24752	1	< 0.1%
0.25063	1	< 0.1%

Value	Count	Frequency (%)
100	15906	5.7%
99.85401	1	< 0.1%
99.814471	1	< 0.1%
99.811321	1	< 0.1%
99.809524	1	< 0.1%
99.7992	1	< 0.1%
99.795082	1	< 0.1%
99.78587	1	< 0.1%
99.776786	1	< 0.1%
99.77578	1	< 0.1%

Footnote for Q3 Measure Score
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	233440
Missing (%)	83.3%
Memory size	4.3 MiB

9.0	46008
10.0	956

Length

Max length	4
Median length	3
Mean length	3.020356017
Min length	3

Characters and Unicode

Total characters	141848
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9.0
2nd row	9.0
3rd row	9.0
4th row	9.0
5th row	9.0

Common Values

Value	Count	Frequency (%)
9.0	46008	16.4%
10.0	956	0.3%
(Missing)	233440	83.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
9.0	46008	98.0%
10.0	956	2.0%

Most occurring characters

Value	Count	Frequency (%)
0	47920	33.8%
.	46964	33.1%
9	46008	32.4%
1	956	0.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	94884	66.9%
Other Punctuation	46964	33.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	47920	50.5%
9	46008	48.5%
1	956	1.0%

Other Punctuation

Value	Count	Frequency (%)
.	46964	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	141848	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	47920	33.8%
.	46964	33.1%
9	46008	32.4%
1	956	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	141848	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	47920	33.8%
.	46964	33.1%
9	46008	32.4%
1	956	0.7%

Q4 Measure Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	37922
Distinct (%)	16.5%
Missing	49932
Missing (%)	17.8%
Infinite	0
Infinite (%)	0.0%
Mean	31.43156472

Minimum	0
Maximum	100
Zeros	42025
Zeros (%)	15.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.29645475
median	12.5
Q3	62.889088
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	60.59263325

Descriptive statistics

Standard deviation	36.88881258
Coefficient of variation (CV)	1.173623168
Kurtosis	-0.839584725
Mean	31.43156472
Median Absolute Deviation (MAD)	12.5
Skewness	0.9100430839
Sum	7244095.585
Variance	1360.784493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	42025	15.0%
100	15418	5.5%
10	948	0.3%
14.28571	931	0.3%
12.5	885	0.3%
9.09091	877	0.3%
16.66667	872	0.3%
20	817	0.3%
8.33333	791	0.3%
11.11111	783	0.3%
Other values (37912)	166125	59.2%
(Missing)	49932	17.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	42025	15.0%
0.14104	1	< 0.1%
0.149306	1	< 0.1%
0.16611	1	< 0.1%
0.187448	1	< 0.1%
0.19157	1	< 0.1%
0.19569	1	< 0.1%
0.20964	1	< 0.1%
0.224627	1	< 0.1%
0.22779	1	< 0.1%

Value	Count	Frequency (%)
100	15418	5.5%
99.86207	1	< 0.1%
99.814471	1	< 0.1%
99.811321	1	< 0.1%
99.809524	1	< 0.1%
99.795082	1	< 0.1%
99.79339	1	< 0.1%
99.78355	1	< 0.1%
99.776786	1	< 0.1%
99.773756	1	< 0.1%

Footnote for Q4 Measure Score
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	230472
Missing (%)	82.2%
Memory size	4.3 MiB

9.0	49246
10.0	686

Length

Max length	4
Median length	3
Mean length	3.013738685
Min length	3

Characters and Unicode

Total characters	150482
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9.0
2nd row	9.0
3rd row	9.0
4th row	9.0
5th row	9.0

Common Values

Value	Count	Frequency (%)
9.0	49246	17.6%
10.0	686	0.2%
(Missing)	230472	82.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
9.0	49246	98.6%
10.0	686	1.4%

Most occurring characters

Value	Count	Frequency (%)
0	50618	33.6%
.	49932	33.2%
9	49246	32.7%
1	686	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	100550	66.8%
Other Punctuation	49932	33.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	50618	50.3%
9	49246	49.0%
1	686	0.7%

Other Punctuation

Value	Count	Frequency (%)
.	49932	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	150482	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	50618	33.6%
.	49932	33.2%
9	49246	32.7%
1	686	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	150482	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	50618	33.6%
.	49932	33.2%
9	49246	32.7%
1	686	0.5%

Four Quarter Average Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	114504
Distinct (%)	42.8%
Missing	12836
Missing (%)	4.6%
Infinite	0
Infinite (%)	0.0%
Mean	31.87993993

Minimum	0
Maximum	100
Zeros	28025
Zeros (%)	10.0%
Negative	0
Negative (%)	0.0%
Memory size	4.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.631579
median	13.0519075
Q3	64.37413525
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	61.74255625

Descriptive statistics

Standard deviation	36.50061441
Coefficient of variation (CV)	1.144939874
Kurtosis	-0.8783855388
Mean	31.87993993
Median Absolute Deviation (MAD)	12.42199
Skewness	0.8811712984
Sum	8530051.768
Variance	1332.294852
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	28025	10.0%
100	13702	4.9%
85.714286	187	0.1%
87.5	187	0.1%
83.333333	186	0.1%
80	178	0.1%
90	177	0.1%
66.666667	165	0.1%
88.888889	152	0.1%
93.333333	143	0.1%
Other values (114494)	224466	80.1%
(Missing)	12836	4.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	28025	10.0%
0.04042	1	< 0.1%
0.050929	1	< 0.1%
0.056722	1	< 0.1%
0.057891	1	< 0.1%
0.061349	1	< 0.1%
0.066801	1	< 0.1%
0.067704	1	< 0.1%
0.069801	1	< 0.1%
0.070472	1	< 0.1%

Value	Count	Frequency (%)
100	13702	4.9%
99.944474	1	< 0.1%
99.93477	1	< 0.1%
99.926254	1	< 0.1%
99.918633	1	< 0.1%
99.910315	1	< 0.1%
99.908425	1	< 0.1%
99.908174	1	< 0.1%
99.90619	1	< 0.1%
99.90263	1	< 0.1%

Footnote for Four Quarter Average Score
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	267568
Missing (%)	95.4%
Memory size	4.3 MiB

9.0	12390
10.0	446

Length

Max length	4
Median length	3
Mean length	3.034746027
Min length	3

Characters and Unicode

Total characters	38954
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9.0
2nd row	9.0
3rd row	9.0
4th row	9.0
5th row	9.0

Common Values

Value	Count	Frequency (%)
9.0	12390	4.4%
10.0	446	0.2%
(Missing)	267568	95.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
9.0	12390	96.5%
10.0	446	3.5%

Most occurring characters

Value	Count	Frequency (%)
0	13282	34.1%
.	12836	33.0%
9	12390	31.8%
1	446	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	26118	67.0%
Other Punctuation	12836	33.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	13282	50.9%
9	12390	47.4%
1	446	1.7%

Other Punctuation

Value	Count	Frequency (%)
.	12836	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	38954	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	13282	34.1%
.	12836	33.0%
9	12390	31.8%
1	446	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38954	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	13282	34.1%
.	12836	33.0%
9	12390	31.8%
1	446	1.1%

Used in Quality Measure Five Star Rating
Categorical

HIGH CORRELATION
HIGH CORRELATION
UNIFORM

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.4 MiB

N	140202
Y	140202

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	280404
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Y
2nd row	N
3rd row	N
4th row	Y
5th row	Y

Common Values

Value	Count	Frequency (%)
N	140202	50.0%
Y	140202	50.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
n	140202	50.0%
y	140202	50.0%

Most occurring characters

Value	Count	Frequency (%)
Y	140202	50.0%
N	140202	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	280404	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
Y	140202	50.0%
N	140202	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	280404	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
Y	140202	50.0%
N	140202	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	280404	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
Y	140202	50.0%
N	140202	50.0%

Measure Period
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

2020Q1-2020Q4	280404

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	3645252
Distinct characters	6
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020Q1-2020Q4
2nd row	2020Q1-2020Q4
3rd row	2020Q1-2020Q4
4th row	2020Q1-2020Q4
5th row	2020Q1-2020Q4

Common Values

Value	Count	Frequency (%)
2020Q1-2020Q4	280404	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2020q1-2020q4	280404	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	1121616	30.8%
0	1121616	30.8%
Q	560808	15.4%
1	280404	7.7%
-	280404	7.7%
4	280404	7.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2804040	76.9%
Uppercase Letter	560808	15.4%
Dash Punctuation	280404	7.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1121616	40.0%
0	1121616	40.0%
1	280404	10.0%
4	280404	10.0%

Uppercase Letter

Value	Count	Frequency (%)
Q	560808	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	280404	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3084444	84.6%
Latin	560808	15.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1121616	36.4%
0	1121616	36.4%
1	280404	9.1%
-	280404	9.1%
4	280404	9.1%

Latin

Value	Count	Frequency (%)
Q	560808	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3645252	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1121616	30.8%
0	1121616	30.8%
Q	560808	15.4%
1	280404	7.7%
-	280404	7.7%
4	280404	7.7%

Location
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	15289
Distinct (%)	5.5%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

4510 27TH ST, LUBBOCK, TX, 79410	198
8810 LONG POINT DR, HOUSTON, TX, 77055	198
1201 CLARKS DR, ABILENE, TX, 79602	126
460 W MAIN ST, RANGER, TX, 76470	126
507 E W M WATSON BLVD, DAINGERFIELD, TX, 75638	108
Other values (15284)	279648

Length

Max length	75
Median length	40
Mean length	40.50584157
Min length	26

Characters and Unicode

Total characters	11358000
Distinct characters	54
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653
2nd row	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653
3rd row	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653
4th row	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653
5th row	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653

Common Values

Value	Count	Frequency (%)
4510 27TH ST, LUBBOCK, TX, 79410	198	0.1%
8810 LONG POINT DR, HOUSTON, TX, 77055	198	0.1%
1201 CLARKS DR, ABILENE, TX, 79602	126	< 0.1%
460 W MAIN ST, RANGER, TX, 76470	126	< 0.1%
507 E W M WATSON BLVD, DAINGERFIELD, TX, 75638	108	< 0.1%
25150 LAKECREST MANOR DR, KATY, TX, 77493	90	< 0.1%
3640 HAMPTON DR, MISSOURI CITY, TX, 77459	90	< 0.1%
11830 NORTHPOINTE BOULEVARD, TOMBALL, TX, 77377	90	< 0.1%
12520 FM 1840, DE KALB, TX, 75559	90	< 0.1%
1260 ABRAMS RD, DALLAS, TX, 75214	90	< 0.1%
Other values (15279)	279198	99.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
street	53298	2.8%
road	39564	2.1%
avenue	31896	1.7%
tx	26766	1.4%
drive	25326	1.3%
st	24066	1.3%
ca	21312	1.1%
oh	17172	0.9%
west	17028	0.9%
north	16794	0.9%
Other values (22664)	1635984	85.7%

Most occurring characters

Value	Count	Frequency (%)
	1632276	14.4%
,	845172	7.4%
E	715644	6.3%
A	612036	5.4%
R	509670	4.5%
T	501048	4.4%
N	481626	4.2%
O	460458	4.1%
0	412776	3.6%
S	394218	3.5%
Other values (44)	4793076	42.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6403590	56.4%
Decimal Number	2463408	21.7%
Space Separator	1632276	14.4%
Other Punctuation	856224	7.5%
Dash Punctuation	2268	< 0.1%
Lowercase Letter	162	< 0.1%
Open Punctuation	36	< 0.1%
Close Punctuation	36	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	715644	11.2%
A	612036	9.6%
R	509670	8.0%
T	501048	7.8%
N	481626	7.5%
O	460458	7.2%
S	394218	6.2%
L	382932	6.0%
I	368802	5.8%
D	258084	4.0%
Other values (16)	1719072	26.8%

Decimal Number

Value	Count	Frequency (%)
0	412776	16.8%
1	367452	14.9%
2	268290	10.9%
5	250308	10.2%
3	237384	9.6%
4	233514	9.5%
7	197838	8.0%
6	197208	8.0%
8	152784	6.2%
9	145854	5.9%

Lowercase Letter

Value	Count	Frequency (%)
a	36	22.2%
i	18	11.1%
r	18	11.1%
b	18	11.1%
n	18	11.1%
k	18	11.1%
s	18	11.1%
d	18	11.1%

Other Punctuation

Value	Count	Frequency (%)
,	845172	98.7%
.	9576	1.1%
'	630	0.1%
#	360	< 0.1%
/	270	< 0.1%
&	216	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1632276	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2268	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	36	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	36	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6403752	56.4%
Common	4954248	43.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	715644	11.2%
A	612036	9.6%
R	509670	8.0%
T	501048	7.8%
N	481626	7.5%
O	460458	7.2%
S	394218	6.2%
L	382932	6.0%
I	368802	5.8%
D	258084	4.0%
Other values (24)	1719234	26.8%

Common

Value	Count	Frequency (%)
	1632276	32.9%
,	845172	17.1%
0	412776	8.3%
1	367452	7.4%
2	268290	5.4%
5	250308	5.1%
3	237384	4.8%
4	233514	4.7%
7	197838	4.0%
6	197208	4.0%
Other values (10)	312030	6.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11358000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1632276	14.4%
,	845172	7.4%
E	715644	6.3%
A	612036	5.4%
R	509670	4.5%
T	501048	4.4%
N	481626	4.2%
O	460458	4.1%
0	412776	3.6%
S	394218	3.5%
Other values (44)	4793076	42.2%

Processing Date
Date

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Minimum	2021-06-01 00:00:00
Maximum	2021-06-01 00:00:00

Histogram

Histogram with fixed size bins (bins=1)

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Federal Provider Number	Penalty Date	Penalty Type	Fine Amount	Payment Denial Start Date	Payment Denial Length in Days	Provider Name	Provider Address	Provider City	Provider State	Provider Zip Code	Measure Code	Measure Description	Resident type	Q1 Measure Score	Footnote for Q1 Measure Score	Q2 Measure Score	Footnote for Q2 Measure Score	Q3 Measure Score	Footnote for Q3 Measure Score	Q4 Measure Score	Footnote for Q4 Measure Score	Four Quarter Average Score	Footnote for Four Quarter Average Score	Used in Quality Measure Five Star Rating	Measure Period	Location	Processing Date
0	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	401	Percentage of long-stay residents whose need for help with daily activities has increased	Long Stay	9.375000	NaN	30.769230	NaN	7.894740	NaN	18.18182	NaN	16.993465	NaN	Y	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01
1	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	404	Percentage of long-stay residents who lose too much weight	Long Stay	8.823530	NaN	12.000000	NaN	12.500000	NaN	4.65116	NaN	9.154929	NaN	N	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01
2	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	405	Percentage of low risk long-stay residents who lose control of their bowels or bladder	Long Stay	NaN	9.0	NaN	9.0	NaN	9.0	NaN	9.0	46.666669	NaN	N	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01
3	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	406	Percentage of long-stay residents with a catheter inserted and left in their bladder	Long Stay	1.791499	NaN	3.645183	NaN	1.374846	NaN	0.00000	NaN	1.494553	NaN	Y	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01
4	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	407	Percentage of long-stay residents with a urinary tract infection	Long Stay	0.000000	NaN	0.000000	NaN	0.000000	NaN	2.17391	NaN	0.636942	NaN	Y	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01
5	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	408	Percentage of long-stay residents who have depressive symptoms	Long Stay	0.000000	NaN	0.000000	NaN	0.000000	NaN	0.00000	NaN	0.000000	NaN	N	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01
6	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	409	Percentage of long-stay residents who were physically restrained	Long Stay	0.000000	NaN	0.000000	NaN	0.000000	NaN	0.00000	NaN	0.000000	NaN	N	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01
7	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	410	Percentage of long-stay residents experiencing one or more falls with major injury	Long Stay	2.380950	NaN	2.272730	NaN	2.380950	NaN	2.08333	NaN	2.272726	NaN	Y	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01
8	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	415	Percentage of long-stay residents assessed and appropriately given the pneumococcal vaccine	Long Stay	100.000000	NaN	100.000000	NaN	100.000000	NaN	100.00000	NaN	100.000000	NaN	N	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01
9	015009	NaT	NaN	NaN	NaT	NaN	BURNS NURSING HOME, INC.	701 MONROE STREET NW	RUSSELLVILLE	AL	35653	419	Percentage of long-stay residents who received an antipsychotic medication	Long Stay	10.256410	NaN	7.142860	NaN	10.000000	NaN	15.21739	NaN	10.778443	NaN	Y	2020Q1-2020Q4	701 MONROE STREET NW, RUSSELLVILLE, AL, 35653	2021-06-01

Last rows

	Federal Provider Number	Penalty Date	Penalty Type	Fine Amount	Payment Denial Start Date	Payment Denial Length in Days	Provider Name	Provider Address	Provider City	Provider State	Provider Zip Code	Measure Code	Measure Description	Resident type	Q1 Measure Score	Footnote for Q1 Measure Score	Q2 Measure Score	Footnote for Q2 Measure Score	Q3 Measure Score	Footnote for Q3 Measure Score	Q4 Measure Score	Footnote for Q4 Measure Score	Four Quarter Average Score	Footnote for Four Quarter Average Score	Used in Quality Measure Five Star Rating	Measure Period	Location	Processing Date
280394	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	415	Percentage of long-stay residents assessed and appropriately given the pneumococcal vaccine	Long Stay	100.000000	NaN	100.000000	NaN	100.000000	NaN	100.000000	NaN	100.000000	NaN	N	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01
280395	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	419	Percentage of long-stay residents who received an antipsychotic medication	Long Stay	25.161290	NaN	21.518990	NaN	17.647060	NaN	19.867550	NaN	21.069693	NaN	Y	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01
280396	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	430	Percentage of short-stay residents assessed and appropriately given the pneumococcal vaccine	Short Stay	100.000000	NaN	100.000000	NaN	100.000000	NaN	99.166670	NaN	99.808062	NaN	N	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01
280397	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	434	Percentage of short-stay residents who newly received an antipsychotic medication	Short Stay	3.370790	NaN	4.285710	NaN	6.382980	NaN	8.928570	NaN	5.343511	NaN	Y	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01
280398	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	451	Percentage of long-stay residents whose ability to move independently worsened	Long Stay	15.424086	NaN	29.485561	NaN	25.439255	NaN	25.277411	NaN	23.990931	NaN	Y	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01
280399	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	452	Percentage of long-stay residents who received an antianxiety or hypnotic medication	Long Stay	29.007630	NaN	31.884060	NaN	30.935250	NaN	31.428570	NaN	30.839415	NaN	N	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01
280400	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	453	Percentage of high risk long-stay residents with pressure ulcers	Long Stay	9.420290	NaN	9.285710	NaN	8.695650	NaN	7.299270	NaN	8.679926	NaN	Y	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01
280401	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	454	Percentage of long-stay residents assessed and appropriately given the seasonal influenza vaccine	Long Stay	98.837209	NaN	98.837209	NaN	98.837209	NaN	98.837209	NaN	98.837209	NaN	N	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01
280402	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	471	Percentage of short-stay residents who made improvements in function	Short Stay	51.717807	NaN	50.063450	NaN	30.140461	NaN	40.048864	NaN	45.613111	NaN	Y	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01
280403	686124	NaT	NaN	NaN	NaT	NaN	HARMONY HEALTH CENTER	9820 N KENDALL DRIVE	MIAMI	FL	33176	472	Percentage of short-stay residents who were assessed and appropriately given the seasonal influenza vaccine	Short Stay	96.195652	NaN	96.195652	NaN	96.195652	NaN	96.195652	NaN	96.195652	NaN	N	2020Q1-2020Q4	9820 N KENDALL DRIVE, MIAMI, FL, 33176	2021-06-01

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Punctuation

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category